﻿CREATE TABLE [dbo].[EntryLogLogging] (
    [EntryLogID]            INT             NOT NULL,
    [Description]           NVARCHAR (255)  NOT NULL,
    [Duration]              DECIMAL (10, 2) NOT NULL,
    [EntryDate]             SMALLDATETIME   NOT NULL,
    [ProjectID]             INT             NOT NULL,
    [UserID]                INT             NOT NULL,
    [CategoryID]            INT             NOT NULL,
    [HasBeenBilled]         BIT             NOT NULL,
    [OvernightStay]         BIT             NOT NULL,
    [BillableHours]         DECIMAL (10, 2) NOT NULL,
    [EntryCreateDate]       DATETIME        NULL,
    [HoursAdjustmentReason] NVARCHAR (100)  NULL,
    [BillingStateID]        INT             NOT NULL,
    [ReviewByAdmin]         BIT             NOT NULL
);

